package com.estate.mapper;

import com.estate.pojo.Project;
import java.util.List;
import org.apache.ibatis.annotations.Param;

public interface ProjectMapper {
	
	//按主项目id查询主项目id，项目名称和分期项目的信息
	public List<Project> getMessByPorId(@Param(value = "ProId")Integer ProId) throws Exception;
	
	// 查询所有项目名称和项目所在的城市名称
    List<Project> allProNameAndCityName() throws Exception;
    
    //查询所有项目
    List<Project> getAllProject();
    
    //根据项目id查找主项目下的子项目下的区域下的楼栋信息
    List<Project> getProjectByProId(@Param(value = "ProId")Integer ProId)throws Exception;
  
    int deleteByPrimaryKey(Integer projectId)throws Exception;

    int insert(Project record)throws Exception;

    int insertSelective(Project record)throws Exception;
    
    // 按主键查询主项目信息
    Project selectByPrimaryKey(Integer projectId) throws Exception;

    int updateByPrimaryKeySelective(Project record) throws Exception;

    int updateByPrimaryKey(Project record)throws Exception;
    
}